﻿CREATE TABLE [dbo].[tbl_member]
(
	[member_id] int IDENTITY(1,1) NOT NULL,
	[UserId] uniqueidentifier NOT NULL,
	[firstname_txt] nvarchar(100) NULL,
	[lastname_txt] nvarchar(100) NULL,
	[korean_nm] nvarchar(10) NULL,
	[address_txt] nvarchar(255) NULL,
	[address2_txt] nvarchar(255) NULL,
	[city_txt] nvarchar(255) NULL,
	[state_cd] varchar(2) NULL,
	[zip_cd] varchar(10) NULL,
	[country_nm] nvarchar(255) NULL,
	[homephone_txt] varchar(25) NULL,
	[cellphone_txt] varchar(25) NULL,
	[birthdate_dt] datetime NULL,
	[icon_filename_txt] nvarchar(512) NULL,
	[member_since_dt] datetime NULL,
	[last_login_dttm] datetime NULL,
	[confirmation_guid] uniqueidentifier NULL,
	[created_dttm] datetime NOT NULL,
	[smallgroup_id] uniqueidentifier NULL
)
